package com.example.sxmall.dao.mapper;

import com.example.sxmall.dao.pojo.ShoesSizes;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface ShoesizesMapper {
    /**
     * 查看尺寸列表
     * @return
     */
    public List<ShoesSizes> listShoesSizes();

    /**
     * 根据ID查询尺寸
     * @param ssid
     * @return
     */
    public ShoesSizes findShoesSizesById(@Param("ssid") Integer ssid);

    /**
     * 根据鞋子ID查询
     * @param s_sid
     * @return
     */
    public List<ShoesSizes> findShoesSizesBySid(@Param("s_sid") Integer s_sid);

    /**
     * 根据尺码ID查询
     * @param s_sizeid
     * @return
     */
    public List<ShoesSizes> findShoesSizesBySizeid(@Param("s_sizeid") Integer s_sizeid);

    /**
     * 添加
     * @param shoesSizes
     * @return
     */
    public int insertShoesSizes(@Param("shoesSizes") ShoesSizes shoesSizes);

    /**
     * 删除
     * @param ssid
     * @return
     */
    public int deleteShoesSizes(@Param("ssid") int ssid);

    /**
     * 动态修改
     * @param shoesSizes
     * @return
     */
    public int updateShoesSizes(@Param("shoesSizes") ShoesSizes shoesSizes);
}
